
insert Poster([Name], ContactName) values('Super Jobs', 'Mike Hadlow')
insert Poster([Name], ContactName) values('Future You', 'Etsuko Hara')
insert Poster([Name], ContactName) values('Bright Star', 'Greg Smith')

declare @topLocationId int
insert Location([Name], ParentId) values('All', null)
set @topLocationId = @@identity
insert Location([Name], ParentId) values('UK', @topLocationId)
insert Location([Name], ParentId) values('London', @topLocationId + 1)
insert Location([Name], ParentId) values('City', @topLocationId + 2)
insert Location([Name], ParentId) values('Brighton', @topLocationId + 1)
insert Location([Name], ParentId) values('Eastbourne', @topLocationId + 1)
insert Location([Name], ParentId) values('Croydon', @topLocationId + 1)
insert Location([Name], ParentId) values('Sevenoaks', @topLocationId + 1)

insert Salary(Description) values('up to $15000')
insert Salary(Description) values('$15001 to $25000')
insert Salary(Description) values('$25001 to $50000')
insert Salary(Description) values('$50001 to $75000')
insert Salary(Description) values('more than $75001')

insert Job(Title, Description, Featured, PosterId, LocationId, SalaryId)
values('Rat Catcher', 'We need someone to catch rats. Are you the cat to do it?', 1, 1, @topLocationId + 3, 1)

insert Job(Title, Description, Featured, PosterId, LocationId, SalaryId)
values('Harvester of Eyes', 'Harvester of eyes is that you?', 1, 2, @topLocationId + 3, 5)

insert Job(Title, Description, Featured, PosterId, LocationId, SalaryId)
values('Watcher of the Skies', 'We need someone to watch the skies for aliens. Are you sharp enough?', 1, 3, @topLocationId + 4, 3)

insert Job(Title, Description, Featured, PosterId, LocationId, SalaryId)
values('Hogweed Killer', 'Giant Hogweed is threatening mankind. Help us eradicate it?', 1, 3, @topLocationId + 5, 4)

insert Role([Name]) values('Administrator')
insert Role([Name]) values('Poster')
insert Role([Name]) values('Candidate')
insert Role([Name]) values('Guest')

insert [User]([Name], [Password], RoleId) values('mike', 'mike', 3)
insert [User]([Name], [Password], RoleId) values('admin', 'admin', 1)
insert [User]([Name], [Password], RoleId) values('john', 'john', 2)